﻿<%@ Page Title="" Language="C#" MasterPageFile="MasterPage.master" AutoEventWireup="true" CodeFile="DrugSchedule.aspx.cs" Inherits="WebUI_WECARE_DrugSchedule" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
    <link href="css/DrCss.css" rel="stylesheet" />

<div style="width:960px; height:750px;margin:0 auto;">
<h1 style="color:black;text-align:center;">這是用藥排程頁面</h1>

        <div style="width:260px; height:200px;float:left;">
            <div class="z1">
                <input type="text" class="form-control" placeholder="輸入查詢者姓名"/>
                <span class="input-group-btn">
                    <button class="btn btn-default" type="button">
                        <span class="glyphicon glyphicon-search"></span>
                </button>
                </span>
            </div>
       </div>

        <div style="width:650px; height:500px;margin:0 auto;float:right;">
            
            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
                <Columns>
                    <asp:BoundField DataField="病患名稱" HeaderText="病患名稱" SortExpression="病患名稱" />
                    <asp:BoundField DataField="檢驗名稱" HeaderText="檢驗名稱" SortExpression="檢驗名稱" />
                    <asp:BoundField DataField="檢驗頻率" HeaderText="檢驗頻率" SortExpression="檢驗頻率" />
                    <asp:BoundField DataField="起始日期" HeaderText="起始日期" SortExpression="起始日期" />
                    <asp:BoundField DataField="結束日期" HeaderText="結束日期" SortExpression="結束日期" />
                    <asp:BoundField DataField="備註" HeaderText="備註" SortExpression="備註" />
                    <asp:BoundField DataField="病歷號碼" HeaderText="病歷號碼" SortExpression="病歷號碼" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MedicareConnectionString %>" SelectCommand="SELECT [病患名稱], [檢驗名稱], [檢驗頻率], [起始日期], [結束日期], [備註], [病歷號碼] FROM [View_ExamSchedules] WHERE ([病歷號碼] = @病歷號碼)">
                <SelectParameters>
                    <asp:Parameter DefaultValue="1005" Name="病歷號碼" Type="Int32" />
                </SelectParameters>
            </asp:SqlDataSource>
        </div>

</div>
</asp:Content>

